﻿CREATE TABLE [dbo].[GenBoatData_Tbl] (
    [BoatGenID]                                                INT            IDENTITY (1, 1) NOT NULL,
    [SOURCE]                                                   NVARCHAR (MAX) NULL,
    [BoatMnfID]                                                INT            NULL,
    [Manufacturer]                                             NVARCHAR (MAX) NULL,
    [BoatRange]                                                NVARCHAR (MAX) NULL,
    [BoatModel]                                                NVARCHAR (MAX) NULL,
    [BoatType]                                                 NVARCHAR (MAX) NULL,
    [BoatTypeID]                                               INT            NULL,
    [Draft]                                                    FLOAT          NULL,
    [BoatLoaGrpID]                                             INT            NULL,
    [Loa]                                                      INT            NULL,
    [FirstHullNo]                                              NVARCHAR (MAX) NULL,
    [LastHullNo]                                               NVARCHAR (MAX) NULL,
    [DesignYear]                                               NVARCHAR (MAX) NULL,
    [BoatName]                                                 NVARCHAR (MAX) NULL,
    [SAIL NUMBER]                                              NVARCHAR (MAX) NULL,
    [BoatRigGrpID]                                             INT            NULL,
    [BoatRigGrp]                                               NVARCHAR (MAX) NULL,
    [Smart]                                                    NVARCHAR (MAX) NULL,
    [Expr1]                                                    NVARCHAR (MAX) NULL,
    [Cb]                                                       NVARCHAR (MAX) NULL,
    [CERTIFICATE]                                              NVARCHAR (MAX) NULL,
    [CountryID]                                                INT            NULL,
    [Beam]                                                     FLOAT          NULL,
    [Displ]                                                    FLOAT          NULL,
    [Dl]                                                       NVARCHAR (MAX) NULL,
    [Dwsd]                                                     NVARCHAR (MAX) NULL,
    [Mast No]                                                  NVARCHAR (MAX) NULL,
    [MastID]                                                   INT            NULL,
    [BoomID]                                                   INT            NULL,
    [BAS]                                                      FLOAT          NULL,
    [FL]                                                       FLOAT          NULL,
    [I]                                                        FLOAT          NULL,
    [J]                                                        FLOAT          NULL,
    [P]                                                        FLOAT          NULL,
    [E]                                                        FLOAT          NULL,
    [Py]                                                       FLOAT          NULL,
    [Ey]                                                       FLOAT          NULL,
    [Ios]                                                      FLOAT          NULL,
    [Jos]                                                      FLOAT          NULL,
    [Isp]                                                      FLOAT          NULL,
    [Iss]                                                      FLOAT          NULL,
    [Jss]                                                      FLOAT          NULL,
    [Iys]                                                      FLOAT          NULL,
    [Jys]                                                      FLOAT          NULL,
    [Igs]                                                      FLOAT          NULL,
    [Jgs]                                                      FLOAT          NULL,
    [POLE_SPRIT]                                               NVARCHAR (MAX) NULL,
    [Spl]                                                      FLOAT          NULL,
    [Stl]                                                      FLOAT          NULL,
    [FURLER]                                                   NVARCHAR (MAX) NULL,
    [Fwd_Aft Lower]                                            NVARCHAR (MAX) NULL,
    [Half width at D1 anchorage]                               FLOAT          NULL,
    [Half width at V1 anchorage]                               FLOAT          NULL,
    [HasImage]                                                 BIT            NULL,
    [Headstay1ID]                                              NVARCHAR (MAX) NULL,
    [Headstay1ID2]                                             NVARCHAR (MAX) NULL,
    [Headstay1ID3]                                             NVARCHAR (MAX) NULL,
    [HHB]                                                      FLOAT          NULL,
    [HHW]                                                      FLOAT          NULL,
    [HSA]                                                      FLOAT          NULL,
    [HTW]                                                      FLOAT          NULL,
    [LP]                                                       FLOAT          NULL,
    [LL]                                                       FLOAT          NULL,
    [LLM]                                                      FLOAT          NULL,
    [LLY]                                                      FLOAT          NULL,
    [LPY]                                                      FLOAT          NULL,
    [MHW]                                                      FLOAT          NULL,
    [MTW]                                                      FLOAT          NULL,
    [MUW]                                                      FLOAT          NULL,
    [ASF]                                                      FLOAT          NULL,
    [ASHW]                                                     FLOAT          NULL,
    [ASLE]                                                     FLOAT          NULL,
    [ASLU]                                                     FLOAT          NULL,
    [SL]                                                       FLOAT          NULL,
    [SF]                                                       FLOAT          NULL,
    [SHW]                                                      FLOAT          NULL,
    [SMW]                                                      FLOAT          NULL,
    [SPA]                                                      FLOAT          NULL,
    [Import ID]                                                INT            NULL,
    [Keel Stepped  _Yes_N0]                                    FLOAT          NULL,
    [LastUpdated]                                              DATETIME       NULL,
    [SP1 Ht]                                                   FLOAT          NULL,
    [Length SP1]                                               FLOAT          NULL,
    [Lift SP1]                                                 FLOAT          NULL,
    [SP2]                                                      FLOAT          NULL,
    [Length SP2]                                               FLOAT          NULL,
    [Lift SP2]                                                 FLOAT          NULL,
    [SP3 Ht]                                                   FLOAT          NULL,
    [Length SP3]                                               FLOAT          NULL,
    [Lift SP3]                                                 FLOAT          NULL,
    [Expr2]                                                    FLOAT          NULL,
    [Chainplates_partner]                                      FLOAT          NULL,
    [CHECKSTAYS]                                               FLOAT          NULL,
    [Inter stay]                                               NVARCHAR (MAX) NULL,
    [SPREADERS]                                                NVARCHAR (MAX) NULL,
    [JUMPERS]                                                  NVARCHAR (MAX) NULL,
    [RUNNERS]                                                  NVARCHAR (MAX) NULL,
    [Lower runner]                                             NVARCHAR (MAX) NULL,
    [Main Area]                                                FLOAT          NULL,
    [LWL]                                                      FLOAT          NULL,
    [Mast_deck_Waterline]                                      FLOAT          NULL,
    [BowRake]                                                  FLOAT          NULL,
    [BowShear]                                                 FLOAT          NULL,
    [Angle Chainplates]                                        NVARCHAR (MAX) NULL,
    [Cable type]                                               NVARCHAR (MAX) NULL,
    [Ø Backstay]                                               FLOAT          NULL,
    [Ø D1]                                                     FLOAT          NULL,
    [Ø D1 Avt]                                                 FLOAT          NULL,
    [Ø D2]                                                     FLOAT          NULL,
    [Ø D3]                                                     FLOAT          NULL,
    [Ø Double backstay]                                        FLOAT          NULL,
    [Ø Head stay]                                              FLOAT          NULL,
    [Ø intermediate]                                           FLOAT          NULL,
    [Ø Lower shroud]                                           FLOAT          NULL,
    [Ø Lower stay]                                             FLOAT          NULL,
    [Ø Top shroud]                                             FLOAT          NULL,
    [Ø V1]                                                     FLOAT          NULL,
    [Ø V2]                                                     FLOAT          NULL,
    [Ø V2D3]                                                   FLOAT          NULL,
    [Ø V3D4]                                                   FLOAT          NULL,
    [Ø Y  backstay]                                            FLOAT          NULL,
    [Pied arrière _au pont_ du pataras ou bastaque principale] NVARCHAR (MAX) NULL,
    [Private]                                                  BIT            NULL,
    [Prop]                                                     NVARCHAR (MAX) NULL,
    [Rating]                                                   NVARCHAR (MAX) NULL,
    [Rigging]                                                  NVARCHAR (MAX) NULL,
    [RigType]                                                  NVARCHAR (MAX) NULL,
    [Gz max _m_]                                               FLOAT          NULL,
    [Rm max _kg#m_ Designer]                                   FLOAT          NULL,
    [Rm max  _kg#m_]                                           FLOAT          NULL,
    [RM Test configuration]                                    NVARCHAR (MAX) NULL,
    [SailPlan]                                                 FLOAT          NULL,
    [TranShear]                                                NVARCHAR (MAX) NULL,
    [Upsd]                                                     NVARCHAR (MAX) NULL,
    [Measured]                                                 FLOAT          NULL,
    [MeasurementForm]                                          FLOAT          NULL,
    [Notes]                                                    NVARCHAR (MAX) NULL,
    [Concatstring]                                             NVARCHAR (MAX) NULL,
    [Designer]                                                 NVARCHAR (MAX) NULL
);

